

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<script type="text/javascript" src="helpman_topicinit.js"></script>

<title>ASA ODBC Driver [Enterprise Architect User Guide]</title>

<meta name="keywords" content="Enterprise Architect, Sparx Systems, UML, Model File,Model File Set Up Adaptive Server Anywhere ODBC Driver,Set Up,Set Up Adaptive Server Anywhere ODBC Driver,Sybase Adaptive Server Anywhere,Sybase Adaptive Server Anywhere ODBC Driver, Set Up,ASA,ASA ODBC Driver, Set Up,Adaptive Server Anywhere,Adaptive Server Anywhere ODBC Driver, Set Up">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta http-equiv="Content-Style-Type" content="text/css" />

<link type="text/css" href="default.css" rel="stylesheet" />
<style type="text/css">
  A, A:Visited
  {
    color: #00F;
  }

  A:Active, A:Hover
  {
    color: #F00;
  }

  OL
  {
    margin: 5px 0 5px 48px;
  }

  UL
  {
    margin-bottom: 3px;
    margin-top: 0;
  }

  #nsr
  {
    background-color: #D4DFFF;
  }

  #nsr A
  {
    text-decoration: none;
  }

  #mainbody
  {
    padding: 8px;
  }

  .p_BodyText
  {
    padding: 5px 0;
  }
</style>



<style type="text/css" media="screen">
  BODY
  {
    background-color: #FFFFFF;
  }

  #nsr
  {
    padding: 6px 6px 0 6px;
    border-bottom: none;
    vertical-align: top;
    z-index: 2;
    visibility: visible;
    left: 0;
    top: 0;
    position: absolute;
  }

  #mainbody
  {
    left: 0;
    top: 0;
    margin: 0;
    position: absolute;
    padding: 10px;
    overflow: auto;
    height: 100%;
    z-index: 1;
    background-repeat: no-repeat;
    background-position: bottom right;
    background-attachment: fixed;
  }
</style>

<style type="text/css" media="print">
  #nsr
  {
    visibility: none;
  }

  #mainbody
  {
    overflow: visible;
  }
</style>
<script type="text/javascript" language="JavaScript" src="nonscroll.js"></script>

</head>
<body scroll="no">

<div id="page">



        <div id="content">
          <div id="content-inner">
          



  
          <div id="nsr">
            <table border="0" cellspacing="0" cellpadding="4" width="100%">
              <tr valign="top">
                <td align="left">
  


                  <p class="p_Heading1"><span class="f_Heading1">ASA ODBC Driver</span></p>



  
                </td>
                <td align="right">
                  <a href="introduction.htm" onmouseover="document.images.main.src='button_main_h.gif'" onmouseout="document.images.main.src='button_main.gif'">
                    <img name="main" src="button_main.gif" border=0 alt="Return to Introduction">
                  </a>&nbsp;
    
                  <a href="setupapostgresqlodbcdriver.htm" onmouseover="document.images.prev.src='button_prev_h.gif'" onmouseout="document.images.prev.src='button_prev.gif'">
                    <img name=prev src="button_prev.gif" border=0 alt="Previous page" />
                  </a>&nbsp;
    
    
    
                  <a href="setupprogressopenedgeodbc.htm" onmouseover="document.images.next.src='button_next_h.gif'" onmouseout="document.images.next.src='button_next.gif'">
                    <img name=next src="button_next.gif" border=0 alt="Next page" />
                  </a>
    
    
                </td>
              </tr>
            </table>
          </div>
          <div id="mainbody">
  


                <p class="p_BodyText"><span class="f_BodyText">Before you can connect to an Adaptive Server Anywhere (ASA) data repository, you must first set up an ASA ODBC driver. To do this, you must have Microsoft MDAC components, the ASA DBMS system and the ASA ODBC driver (installed with the ASA DBMS) installed.</span></p>
<p class="p_BodyText"><span class="f_BodyText">To set up your ASA ODBC Driver, follow the steps below:</span></p>
<ol style="text-indent: 0px; margin-left: 48px; list-style-position: outside;">
<li value=1><span class="f_NumberedList">Select the Windows</span><span class="f_NumberedList" style="font-size: 6pt; vertical-align: super;">TM</span><span class="f_NumberedList"> </span><span class="f_MenuKeyField">Control Panel | Administrative Tools | Data Sources (ODBC)</span><span class="f_NumberedList"> option. The </span><span class="f_UIControl">ODBC Data Sources Administrator</span><span class="f_NumberedList"> window displays.</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<img src="asa-odbcdialog.png" width="452" height="346" border="0" alt="ASA-ODBCDialog"><br>
<span class="f_NumberedList">&nbsp;</span></li>
<li value=2><span class="f_NumberedList">Click on the </span><span class="f_MenuKeyField">Add</span><span class="f_NumberedList"> button. The </span><span class="f_UIControl">Create New Data Source</span><span class="f_NumberedList"> dialog displays, enabling you to add a new DSN.</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<img src="odbc_newdsn.png" width="461" height="320" border="0" alt="ODBC_NewDSN"><br>
<span class="f_NumberedList">&nbsp;</span></li>
<li value=3><span class="f_NumberedList">Select </span><span class="f_MenuKeyField">Adaptive Server Anywhere 8.0</span><span class="f_NumberedList"> from the list.</span></li>
<li value=4><span class="f_NumberedList">Click on the </span><span class="f_MenuKeyField">Finish</span><span class="f_NumberedList"> button.</span></li>
<li value=5><span class="f_NumberedList">Enter the following configuration details:</span></li>
</ol>
<ul style="text-indent: 0px; margin-left: 65px; list-style-position: outside;">
<li><span class="f_Bulletlist3">A name for the connection on the </span><span class="f_UIControl">ODBC</span><span class="f_Bulletlist3"> tab.</span><br>
<span class="f_Bulletlist3">&nbsp;</span><br>
<img src="asa-configuration-odbc.png" width="332" height="458" border="0" alt="ASA-Configuration-ODBC"><br>
<span class="f_Bulletlist3">&nbsp;</span></li>
<li><span class="f_Bulletlist3">The username and password on the </span><span class="f_UIControl">Login</span><span class="f_Bulletlist3"> tab (</span><span class="f_MenuKeyField">dba</span><span class="f_Bulletlist3">, </span><span class="f_MenuKeyField">sql</span><span class="f_Bulletlist3"> are the defaults when ASA is installed).</span><br>
<span class="f_Bulletlist3">&nbsp;</span><br>
<img src="asa-configuration-login.png" width="332" height="163" border="0" alt="ASA-Configuration-Login"><br>
<span class="f_Bulletlist3">&nbsp;</span></li>
<li><span class="f_Bulletlist3">The server name and the path to the database, on the </span><span class="f_UIControl">Database</span><span class="f_Bulletlist3"> tab.</span><br>
<span class="f_Bulletlist3">&nbsp;</span><br>
<img src="asa-configuration-database.png" width="336" height="268" border="0" alt="ASA-Configuration-Database"><br>
<span class="f_Bulletlist3">&nbsp;</span></li>
<li><span class="f_Bulletlist3">The network protocol on the </span><span class="f_UIControl">Network</span><span class="f_Bulletlist3"> tab (if the database is on a network location).</span><br>
<span class="f_Bulletlist3">&nbsp;</span><br>
<img src="asa-configuration-network.png" width="334" height="458" border="0" alt="ASA-Configuration-Network"><br>
<span class="f_Bulletlist3">&nbsp;</span></li>
</ul>
<ol style="text-indent: 0px; margin-left: 48px; list-style-position: outside;">
<li value=6><span class="f_NumberedList">You can now return to the </span><span class="f_UIControl">ODBC</span><span class="f_NumberedList"> tab and test the connection.</span></li>
<li value=7><span class="f_NumberedList">Click on the </span><span class="f_MenuKeyField">OK</span><span class="f_NumberedList"> button to complete the configuration.</span></li>
</ol>
<p class="p_BodyText"><span class="f_BodyText">Your Adaptive Server Anywhere connection is now available to use in Enterprise Architect.</span></p>




            </div>
          </div>
        </div>



</div>


</body>
</html>
